<html>
<head>
<title>File Source for Worksheet.php</title>
<link rel="stylesheet" type="text/css" href="../media/style.css">
</head>
<body>

<table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
  <tr>
    <td class="header_top">PHPExcel</td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
  <tr>
    <td class="header_menu">
  		  [ <a href="../classtrees_PHPExcel.html" class="menu">class tree: PHPExcel</a> ]
		  [ <a href="../elementindex_PHPExcel.html" class="menu">index: PHPExcel</a> ]
		  [ <a href="../elementindex.html" class="menu">all elements</a> ]
    </td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
</table>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="200" class="menu">
      <b>Packages:</b><br />
              <a href="../li_PHPExcel.html">PHPExcel</a><br />
              <a href="../li_PHPExcel_Cell.html">PHPExcel_Cell</a><br />
              <a href="../li_PHPExcel_Reader.html">PHPExcel_Reader</a><br />
              <a href="../li_PHPExcel_Shared.html">PHPExcel_Shared</a><br />
              <a href="../li_PHPExcel_Style.html">PHPExcel_Style</a><br />
              <a href="../li_PHPExcel_Worksheet.html">PHPExcel_Worksheet</a><br />
              <a href="../li_PHPExcel_Worksheet_Drawing.html">PHPExcel_Worksheet_Drawing</a><br />
              <a href="../li_PHPExcel_Writer.html">PHPExcel_Writer</a><br />
              <a href="../li_PHPExcel_Writer_Excel2007.html">PHPExcel_Writer_Excel2007</a><br />
            <br /><br />
                  
                </td>
    <td>
      <table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">

<h1 align="center">Source for file Worksheet.php</h1>
<p>Documentation is available at <a href="../PHPExcel/_Classes_PHPExcel_Worksheet_php.html">Worksheet.php</a></p>
<div class="php">
<div class="listing"><pre><ol><li><a name="a1"></a><span class="src-php">&lt;?php</span></li>
<li><a name="a2"></a><span class="src-doc">/**</span></li>
<li><a name="a3"></a><span class="src-doc"> * PHPExcel</span></li>
<li><a name="a4"></a><span class="src-doc"> *</span></li>
<li><a name="a5"></a><span class="src-doc"> * Copyright (c) 2006 - 2007 PHPExcel, Maarten Balliauw</span></li>
<li><a name="a6"></a><span class="src-doc"> *</span></li>
<li><a name="a7"></a><span class="src-doc"> * This library is free software; you can redistribute it and/or</span></li>
<li><a name="a8"></a><span class="src-doc"> * modify it under the terms of the GNU Lesser General Public</span></li>
<li><a name="a9"></a><span class="src-doc"> * License as published by the Free Software Foundation; either</span></li>
<li><a name="a10"></a><span class="src-doc"> * version 2.1 of the License, or (at your option) any later version.</span></li>
<li><a name="a11"></a><span class="src-doc"> * </span></li>
<li><a name="a12"></a><span class="src-doc"> * This library is distributed in the hope that it will be useful,</span></li>
<li><a name="a13"></a><span class="src-doc"> * but WITHOUT ANY WARRANTY; without even the implied warranty of</span></li>
<li><a name="a14"></a><span class="src-doc"> * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU</span></li>
<li><a name="a15"></a><span class="src-doc"> * Lesser General Public License for more details.</span></li>
<li><a name="a16"></a><span class="src-doc"> * </span></li>
<li><a name="a17"></a><span class="src-doc"> * You should have received a copy of the GNU Lesser General Public</span></li>
<li><a name="a18"></a><span class="src-doc"> * License along with this library; if not, write to the Free Software</span></li>
<li><a name="a19"></a><span class="src-doc"> * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA</span></li>
<li><a name="a20"></a><span class="src-doc"> *</span></li>
<li><a name="a21"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc">   PHPExcel</span></li>
<li><a name="a22"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc">    PHPExcel</span></li>
<li><a name="a23"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc">  Copyright (c) 2006 - 2007 PHPExcel (http://www.codeplex.com/PHPExcel)</span></li>
<li><a name="a24"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc">    http://www.gnu.org/licenses/lgpl.txt    LGPL</span></li>
<li><a name="a25"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc">    ##VERSION##, ##DATE##</span></li>
<li><a name="a26"></a><span class="src-doc"> */</span></li>
<li><a name="a27"></a>&nbsp;</li>
<li><a name="a28"></a>&nbsp;</li>
<li><a name="a29"></a><span class="src-doc">/** PHPExcel */</span></li>
<li><a name="a29"></a>&nbsp;</li>
<li><a name="a30"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel.php'</span><span class="src-sym">;</span></li>
<li><a name="a31"></a>&nbsp;</li>
<li><a name="a32"></a><span class="src-doc">/** PHPExcel_Cell */</span></li>
<li><a name="a32"></a>&nbsp;</li>
<li><a name="a33"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Cell.php'</span><span class="src-sym">;</span></li>
<li><a name="a34"></a>&nbsp;</li>
<li><a name="a35"></a><span class="src-doc">/** PHPExcel_Worksheet_RowDimension */</span></li>
<li><a name="a35"></a>&nbsp;</li>
<li><a name="a36"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Worksheet/RowDimension.php'</span><span class="src-sym">;</span></li>
<li><a name="a37"></a>&nbsp;</li>
<li><a name="a38"></a><span class="src-doc">/** PHPExcel_Worksheet_ColumnDimension */</span></li>
<li><a name="a38"></a>&nbsp;</li>
<li><a name="a39"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Worksheet/ColumnDimension.php'</span><span class="src-sym">;</span></li>
<li><a name="a40"></a>&nbsp;</li>
<li><a name="a41"></a><span class="src-doc">/** PHPExcel_Worksheet_PageSetup */</span></li>
<li><a name="a41"></a>&nbsp;</li>
<li><a name="a42"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Worksheet/PageSetup.php'</span><span class="src-sym">;</span></li>
<li><a name="a43"></a>&nbsp;</li>
<li><a name="a44"></a><span class="src-doc">/** PHPExcel_Worksheet_PageMargins */</span></li>
<li><a name="a44"></a>&nbsp;</li>
<li><a name="a45"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Worksheet/PageMargins.php'</span><span class="src-sym">;</span></li>
<li><a name="a46"></a>&nbsp;</li>
<li><a name="a47"></a><span class="src-doc">/** PHPExcel_Worksheet_HeaderFooter */</span></li>
<li><a name="a47"></a>&nbsp;</li>
<li><a name="a48"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Worksheet/HeaderFooter.php'</span><span class="src-sym">;</span></li>
<li><a name="a49"></a>&nbsp;</li>
<li><a name="a50"></a><span class="src-doc">/** PHPExcel_Worksheet_Drawing */</span></li>
<li><a name="a50"></a>&nbsp;</li>
<li><a name="a51"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Worksheet/Drawing.php'</span><span class="src-sym">;</span></li>
<li><a name="a52"></a>&nbsp;</li>
<li><a name="a53"></a><span class="src-doc">/** PHPExcel_Worksheet_Protection */</span></li>
<li><a name="a53"></a>&nbsp;</li>
<li><a name="a54"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Worksheet/Protection.php'</span><span class="src-sym">;</span></li>
<li><a name="a55"></a>&nbsp;</li>
<li><a name="a56"></a><span class="src-doc">/** PHPExcel_Style */</span></li>
<li><a name="a56"></a>&nbsp;</li>
<li><a name="a57"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Style.php'</span><span class="src-sym">;</span></li>
<li><a name="a58"></a>&nbsp;</li>
<li><a name="a59"></a><span class="src-doc">/** PHPExcel_IComparable */</span></li>
<li><a name="a59"></a>&nbsp;</li>
<li><a name="a60"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/IComparable.php'</span><span class="src-sym">;</span></li>
<li><a name="a61"></a>&nbsp;</li>
<li><a name="a62"></a><span class="src-doc">/** PHPExcel_Shared_PasswordHasher */</span></li>
<li><a name="a62"></a>&nbsp;</li>
<li><a name="a63"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Shared/PasswordHasher.php'</span><span class="src-sym">;</span></li>
<li><a name="a64"></a>&nbsp;</li>
<li><a name="a65"></a>&nbsp;</li>
<li><a name="a66"></a><span class="src-doc">/**</span></li>
<li><a name="a67"></a><span class="src-doc"> * PHPExcel_Worksheet</span></li>
<li><a name="a68"></a><span class="src-doc"> *</span></li>
<li><a name="a69"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc">   PHPExcel</span></li>
<li><a name="a70"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc">    PHPExcel</span></li>
<li><a name="a71"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc">  Copyright (c) 2006 - 2007 PHPExcel (http://www.codeplex.com/PHPExcel)</span></li>
<li><a name="a72"></a><span class="src-doc"> */</span></li>
<li><a name="a73"></a><span class="src-key">class </span><a href="../PHPExcel/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> <span class="src-key">implements </span><span class="src-id">PHPExcel_IComparable</span></li>
<li><a name="a74"></a><span class="src-sym">{</span></li>
<li><a name="a75"></a>    <span class="src-comm">/* Break types */</span></li>
<li><a name="a76"></a>    <span class="src-key">const </span><span class="src-id">BREAK_NONE    </span>= <span class="src-num">0</span><span class="src-sym">;</span></li>
<li><a name="a77"></a>    <span class="src-key">const </span><span class="src-id">BREAK_ROW        </span>= <span class="src-num">1</span><span class="src-sym">;</span></li>
<li><a name="a78"></a>    <span class="src-key">const </span><span class="src-id">BREAK_COLUMN    </span>= <span class="src-num">2</span><span class="src-sym">;</span></li>
<li><a name="a79"></a>    </li>
<li><a name="a80"></a>    <span class="src-doc">/**</span></li>
<li><a name="a81"></a><span class="src-doc">     * Parent spreadsheet</span></li>
<li><a name="a82"></a><span class="src-doc">     *</span></li>
<li><a name="a83"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">PHPExcel </span></li>
<li><a name="a84"></a><span class="src-doc">     */</span></li>
<li><a name="a85"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_parent">$_parent</a><span class="src-sym">;</span></li>
<li><a name="a86"></a>    </li>
<li><a name="a87"></a>    <span class="src-doc">/**</span></li>
<li><a name="a88"></a><span class="src-doc">     * Collection of cells</span></li>
<li><a name="a89"></a><span class="src-doc">     *</span></li>
<li><a name="a90"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">PHPExcel_Cell[] </span></li>
<li><a name="a91"></a><span class="src-doc">     */</span></li>
<li><a name="a92"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_cellCollection">$_cellCollection</a> = <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a93"></a>    </li>
<li><a name="a94"></a>    <span class="src-doc">/**</span></li>
<li><a name="a95"></a><span class="src-doc">     * Collection of row dimensions</span></li>
<li><a name="a96"></a><span class="src-doc">     *</span></li>
<li><a name="a97"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">PHPExcel_Worksheet_RowDimension[] </span></li>
<li><a name="a98"></a><span class="src-doc">     */</span></li>
<li><a name="a99"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_rowDimensions">$_rowDimensions</a> = <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a100"></a>    </li>
<li><a name="a101"></a>    <span class="src-doc">/**</span></li>
<li><a name="a102"></a><span class="src-doc">     * Collection of column dimensions</span></li>
<li><a name="a103"></a><span class="src-doc">     *</span></li>
<li><a name="a104"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">PHPExcel_Worksheet_ColumnDimension[] </span></li>
<li><a name="a105"></a><span class="src-doc">     */</span></li>
<li><a name="a106"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_columnDimensions">$_columnDimensions</a> = <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a107"></a>    </li>
<li><a name="a108"></a>    <span class="src-doc">/**</span></li>
<li><a name="a109"></a><span class="src-doc">     * Collection of drawings</span></li>
<li><a name="a110"></a><span class="src-doc">     *</span></li>
<li><a name="a111"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">PHPExcel_Worksheet_Drawing[] </span></li>
<li><a name="a112"></a><span class="src-doc">     */</span></li>
<li><a name="a113"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_drawingCollection">$_drawingCollection</a> = <span class="src-id">null</span><span class="src-sym">;</span></li>
<li><a name="a114"></a>    </li>
<li><a name="a115"></a>    <span class="src-doc">/**</span></li>
<li><a name="a116"></a><span class="src-doc">     * Worksheet title</span></li>
<li><a name="a117"></a><span class="src-doc">     *</span></li>
<li><a name="a118"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">string </span></li>
<li><a name="a119"></a><span class="src-doc">     */</span></li>
<li><a name="a120"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_title">$_title</a><span class="src-sym">;</span></li>
<li><a name="a121"></a>    </li>
<li><a name="a122"></a>    <span class="src-doc">/**</span></li>
<li><a name="a123"></a><span class="src-doc">     * Page setup</span></li>
<li><a name="a124"></a><span class="src-doc">     *</span></li>
<li><a name="a125"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">PHPExcel_Worksheet_PageSetup </span></li>
<li><a name="a126"></a><span class="src-doc">     */</span></li>
<li><a name="a127"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_pageSetup">$_pageSetup</a><span class="src-sym">;</span></li>
<li><a name="a128"></a>    </li>
<li><a name="a129"></a>    <span class="src-doc">/**</span></li>
<li><a name="a130"></a><span class="src-doc">     * Page margins</span></li>
<li><a name="a131"></a><span class="src-doc">     *</span></li>
<li><a name="a132"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">PHPExcel_Worksheet_PageMargins </span></li>
<li><a name="a133"></a><span class="src-doc">     */</span></li>
<li><a name="a134"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_pageMargins">$_pageMargins</a><span class="src-sym">;</span></li>
<li><a name="a135"></a>    </li>
<li><a name="a136"></a>    <span class="src-doc">/**</span></li>
<li><a name="a137"></a><span class="src-doc">     * Page header/footer</span></li>
<li><a name="a138"></a><span class="src-doc">     *</span></li>
<li><a name="a139"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">PHPExcel_Worksheet_HeaderFooter </span></li>
<li><a name="a140"></a><span class="src-doc">     */</span></li>
<li><a name="a141"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_headerFooter">$_headerFooter</a><span class="src-sym">;</span></li>
<li><a name="a142"></a>    </li>
<li><a name="a143"></a>    <span class="src-doc">/**</span></li>
<li><a name="a144"></a><span class="src-doc">     * Protection</span></li>
<li><a name="a145"></a><span class="src-doc">     *</span></li>
<li><a name="a146"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">PHPExcel_Worksheet_Protection </span></li>
<li><a name="a147"></a><span class="src-doc">     */</span></li>
<li><a name="a148"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_protection">$_protection</a><span class="src-sym">;</span></li>
<li><a name="a149"></a>    </li>
<li><a name="a150"></a>    <span class="src-doc">/**</span></li>
<li><a name="a151"></a><span class="src-doc">     * Collection of styles</span></li>
<li><a name="a152"></a><span class="src-doc">     *</span></li>
<li><a name="a153"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">PHPExcel_Style[] </span></li>
<li><a name="a154"></a><span class="src-doc">     */</span></li>
<li><a name="a155"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_styles">$_styles</a> = <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a156"></a>    </li>
<li><a name="a157"></a>    <span class="src-doc">/**</span></li>
<li><a name="a158"></a><span class="src-doc">     * Is the current cell collection sorted already?</span></li>
<li><a name="a159"></a><span class="src-doc">     *</span></li>
<li><a name="a160"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">boolean </span></li>
<li><a name="a161"></a><span class="src-doc">     */</span></li>
<li><a name="a162"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_cellCollectionIsSorted">$_cellCollectionIsSorted</a> = <span class="src-id">false</span><span class="src-sym">;</span></li>
<li><a name="a163"></a>    </li>
<li><a name="a164"></a>    <span class="src-doc">/**</span></li>
<li><a name="a165"></a><span class="src-doc">     * Collection of breaks</span></li>
<li><a name="a166"></a><span class="src-doc">     *</span></li>
<li><a name="a167"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">array </span></li>
<li><a name="a168"></a><span class="src-doc">     */</span></li>
<li><a name="a169"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_breaks">$_breaks</a> = <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a170"></a>    </li>
<li><a name="a171"></a>    <span class="src-doc">/**</span></li>
<li><a name="a172"></a><span class="src-doc">     * Collection of merged cell ranges</span></li>
<li><a name="a173"></a><span class="src-doc">     *</span></li>
<li><a name="a174"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">array </span></li>
<li><a name="a175"></a><span class="src-doc">     */</span></li>
<li><a name="a176"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_mergeCells">$_mergeCells</a> = <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a177"></a>    </li>
<li><a name="a178"></a>    <span class="src-doc">/**</span></li>
<li><a name="a179"></a><span class="src-doc">     * Collection of protected cell ranges</span></li>
<li><a name="a180"></a><span class="src-doc">     *</span></li>
<li><a name="a181"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">array </span></li>
<li><a name="a182"></a><span class="src-doc">     */</span></li>
<li><a name="a183"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_protectedCells">$_protectedCells</a> = <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a184"></a>    </li>
<li><a name="a185"></a>    <span class="src-doc">/**</span></li>
<li><a name="a186"></a><span class="src-doc">     * Autofilter Range</span></li>
<li><a name="a187"></a><span class="src-doc">     * </span></li>
<li><a name="a188"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">string </span></li>
<li><a name="a189"></a><span class="src-doc">     */</span></li>
<li><a name="a190"></a>    <span class="src-key">private </span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_autoFilter">$_autoFilter</a> = <span class="src-str">''</span><span class="src-sym">;</span></li>
<li><a name="a191"></a>    </li>
<li><a name="a192"></a>    <span class="src-doc">/**</span></li>
<li><a name="a193"></a><span class="src-doc">     * Create a new worksheet</span></li>
<li><a name="a194"></a><span class="src-doc">     *</span></li>
<li><a name="a195"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">PHPExcel </span><span class="src-doc">        </span><span class="src-doc-var">$pParent </span></li>
<li><a name="a196"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc">        </span><span class="src-doc-var">$pTitle </span></li>
<li><a name="a197"></a><span class="src-doc">     */</span></li>
<li><a name="a198"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#method__construct">__construct</a><span class="src-sym">(</span><span class="src-var">$pParent </span>= <span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$pTitle </span>= <span class="src-str">'Worksheet'</span><span class="src-sym">)</span></li>
<li><a name="a199"></a>    <span class="src-sym">{</span></li>
<li><a name="a200"></a>        <span class="src-comm">// Set parent and title</span></li>
<li><a name="a201"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$pParent</span><span class="src-sym">) </span>&amp;&amp; <span class="src-var">$pParent </span>instanceof <span class="src-id"><a href="../PHPExcel/PHPExcel.html">PHPExcel</a></span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a202"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_parent">_parent</a> = <span class="src-var">$pParent</span><span class="src-sym">;</span></li>
<li><a name="a203"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetTitle">setTitle</a><span class="src-sym">(</span><span class="src-var">$pTitle</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a204"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a205"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid PHPExcel object given.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a206"></a>        <span class="src-sym">}</span></li>
<li><a name="a207"></a>        </li>
<li><a name="a208"></a>        <span class="src-comm">// Set page setup</span></li>
<li><a name="a209"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_pageSetup">_pageSetup</a>             = <span class="src-key">new </span><span class="src-id"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageSetup.html">PHPExcel_Worksheet_PageSetup</a></span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a210"></a>        </li>
<li><a name="a211"></a>        <span class="src-comm">// Set page margins</span></li>
<li><a name="a212"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_pageMargins">_pageMargins</a>         = <span class="src-key">new </span><span class="src-id"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageMargins.html">PHPExcel_Worksheet_PageMargins</a></span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a213"></a>        </li>
<li><a name="a214"></a>        <span class="src-comm">// Set page header/footer</span></li>
<li><a name="a215"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_headerFooter">_headerFooter</a>         = <span class="src-key">new </span><span class="src-id"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a></span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a216"></a>        </li>
<li><a name="a217"></a>        <span class="src-comm">// Create a default style and a default gray125 style</span></li>
<li><a name="a218"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_styles">_styles</a><span class="src-sym">[</span><span class="src-str">'default'</span><span class="src-sym">]     </span>= <span class="src-key">new </span><span class="src-id"><a href="../PHPExcel_Cell/PHPExcel_Style.html">PHPExcel_Style</a></span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a219"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_styles">_styles</a><span class="src-sym">[</span><span class="src-str">'gray125'</span><span class="src-sym">]     </span>= <span class="src-key">new </span><span class="src-id"><a href="../PHPExcel_Cell/PHPExcel_Style.html">PHPExcel_Style</a></span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a220"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_styles">_styles</a><span class="src-sym">[</span><span class="src-str">'gray125'</span><span class="src-sym">]</span><span class="src-sym">-&gt;</span><span class="src-id">getFill</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">setFillType</span><span class="src-sym">(</span><span class="src-id"><a href="../PHPExcel_Style/PHPExcel_Style_Fill.html">PHPExcel_Style_Fill</a></span><span class="src-sym">::</span><span class="src-id">FILL_PATTERN_GRAY125</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a221"></a>        </li>
<li><a name="a222"></a>        <span class="src-comm">// Drawing collection</span></li>
<li><a name="a223"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_drawingCollection">_drawingCollection</a>     = <span class="src-key">new </span><span class="src-id">ArrayObject</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a224"></a>        </li>
<li><a name="a225"></a>        <span class="src-comm">// Protection</span></li>
<li><a name="a226"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_protection">_protection</a>            = <span class="src-key">new </span><span class="src-id"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Protection.html">PHPExcel_Worksheet_Protection</a></span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a227"></a>    <span class="src-sym">}</span></li>
<li><a name="a228"></a>    </li>
<li><a name="a229"></a>    <span class="src-doc">/**</span></li>
<li><a name="a230"></a><span class="src-doc">     * Get collection of cells</span></li>
<li><a name="a231"></a><span class="src-doc">     *</span></li>
<li><a name="a232"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Cell[] </span></li>
<li><a name="a233"></a><span class="src-doc">     */</span></li>
<li><a name="a234"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetCellCollection">getCellCollection</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a235"></a>    <span class="src-sym">{</span></li>
<li><a name="a236"></a>        <span class="src-comm">// Re-order cell collection?</span></li>
<li><a name="a237"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_cellCollectionIsSorted">_cellCollectionIsSorted</a><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a238"></a>            <a href="http://www.php.net/usort">usort</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_cellCollection">_cellCollection</a><span class="src-sym">, </span><span class="src-key">array</span><span class="src-sym">(</span><span class="src-str">'PHPExcel_Cell'</span><span class="src-sym">, </span><span class="src-str">'compareCells'</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a239"></a>        <span class="src-sym">}</span></li>
<li><a name="a240"></a>&nbsp;</li>
<li><a name="a241"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_cellCollection">_cellCollection</a><span class="src-sym">;</span></li>
<li><a name="a242"></a>    <span class="src-sym">}</span></li>
<li><a name="a243"></a>    </li>
<li><a name="a244"></a>    <span class="src-doc">/**</span></li>
<li><a name="a245"></a><span class="src-doc">     * Get collection of row dimensions</span></li>
<li><a name="a246"></a><span class="src-doc">     *</span></li>
<li><a name="a247"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Worksheet_RowDimension[] </span></li>
<li><a name="a248"></a><span class="src-doc">     */</span></li>
<li><a name="a249"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetRowDimensions">getRowDimensions</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a250"></a>    <span class="src-sym">{</span></li>
<li><a name="a251"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_rowDimensions">_rowDimensions</a><span class="src-sym">;</span></li>
<li><a name="a252"></a>    <span class="src-sym">}</span></li>
<li><a name="a253"></a>    </li>
<li><a name="a254"></a>    <span class="src-doc">/**</span></li>
<li><a name="a255"></a><span class="src-doc">     * Get collection of column dimensions</span></li>
<li><a name="a256"></a><span class="src-doc">     *</span></li>
<li><a name="a257"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Worksheet_ColumnDimension[] </span></li>
<li><a name="a258"></a><span class="src-doc">     */</span></li>
<li><a name="a259"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetColumnDimensions">getColumnDimensions</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a260"></a>    <span class="src-sym">{</span></li>
<li><a name="a261"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_columnDimensions">_columnDimensions</a><span class="src-sym">;</span></li>
<li><a name="a262"></a>    <span class="src-sym">}</span></li>
<li><a name="a263"></a>    </li>
<li><a name="a264"></a>    <span class="src-doc">/**</span></li>
<li><a name="a265"></a><span class="src-doc">     * Get collection of drawings</span></li>
<li><a name="a266"></a><span class="src-doc">     *</span></li>
<li><a name="a267"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Worksheet_Drawing[] </span></li>
<li><a name="a268"></a><span class="src-doc">     */</span></li>
<li><a name="a269"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetDrawingCollection">getDrawingCollection</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a270"></a>    <span class="src-sym">{</span></li>
<li><a name="a271"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_drawingCollection">_drawingCollection</a><span class="src-sym">;</span></li>
<li><a name="a272"></a>    <span class="src-sym">}</span></li>
<li><a name="a273"></a>    </li>
<li><a name="a274"></a>    <span class="src-doc">/**</span></li>
<li><a name="a275"></a><span class="src-doc">     * Calculate worksheet dimension</span></li>
<li><a name="a276"></a><span class="src-doc">     *</span></li>
<li><a name="a277"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc"> String containing the dimension of this worksheet</span></li>
<li><a name="a278"></a><span class="src-doc">     */</span></li>
<li><a name="a279"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodcalculateWorksheetDimension">calculateWorksheetDimension</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a280"></a>    <span class="src-sym">{        </span></li>
<li><a name="a281"></a>        <span class="src-comm">// Return</span></li>
<li><a name="a282"></a>        <span class="src-key">return </span><span class="src-str">'A1' </span>. <span class="src-str">':' </span>.  <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetHighestColumn">getHighestColumn</a><span class="src-sym">(</span><span class="src-sym">) </span>. <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetHighestRow">getHighestRow</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a283"></a>    <span class="src-sym">}</span></li>
<li><a name="a284"></a>    </li>
<li><a name="a285"></a>    <span class="src-doc">/**</span></li>
<li><a name="a286"></a><span class="src-doc">     * Get parent</span></li>
<li><a name="a287"></a><span class="src-doc">     *</span></li>
<li><a name="a288"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel </span></li>
<li><a name="a289"></a><span class="src-doc">     */</span></li>
<li><a name="a290"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetParent">getParent</a><span class="src-sym">(</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a291"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_parent">_parent</a><span class="src-sym">;</span></li>
<li><a name="a292"></a>    <span class="src-sym">}</span></li>
<li><a name="a293"></a>    </li>
<li><a name="a294"></a>    <span class="src-doc">/**</span></li>
<li><a name="a295"></a><span class="src-doc">     * Get title</span></li>
<li><a name="a296"></a><span class="src-doc">     *</span></li>
<li><a name="a297"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span></li>
<li><a name="a298"></a><span class="src-doc">     */</span></li>
<li><a name="a299"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetTitle">getTitle</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a300"></a>    <span class="src-sym">{</span></li>
<li><a name="a301"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_title">_title</a><span class="src-sym">;</span></li>
<li><a name="a302"></a>    <span class="src-sym">}</span></li>
<li><a name="a303"></a>    </li>
<li><a name="a304"></a>    <span class="src-doc">/**</span></li>
<li><a name="a305"></a><span class="src-doc">     * Set title</span></li>
<li><a name="a306"></a><span class="src-doc">     *</span></li>
<li><a name="a307"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$pValue </span><span class="src-doc">String containing the dimension of this worksheet</span></li>
<li><a name="a308"></a><span class="src-doc">     */</span></li>
<li><a name="a309"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetTitle">setTitle</a><span class="src-sym">(</span><span class="src-var">$pValue </span>= <span class="src-str">'Worksheet'</span><span class="src-sym">)</span></li>
<li><a name="a310"></a>    <span class="src-sym">{</span></li>
<li><a name="a311"></a>        <span class="src-comm">// Loop trough all sheets in parent PHPExcel and verify unique names</span></li>
<li><a name="a312"></a>        <span class="src-var">$titleCount    </span>= <span class="src-num">0</span><span class="src-sym">;</span></li>
<li><a name="a313"></a>        <span class="src-var">$aNames     </span>= <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetParent">getParent</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getSheetNames</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a314"></a> </li>
<li><a name="a315"></a>        <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$aNames </span><span class="src-key">as </span><span class="src-var">$strName</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a316"></a>            <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$strName </span>== <span class="src-var">$pValue </span>|| <a href="http://www.php.net/substr">substr</a><span class="src-sym">(</span><span class="src-var">$strName</span><span class="src-sym">, </span><span class="src-num">0</span><span class="src-sym">, </span><a href="http://www.php.net/strrpos">strrpos</a><span class="src-sym">(</span><span class="src-var">$strName</span><span class="src-sym">, </span><span class="src-str">' '</span><span class="src-sym">)) </span>== <span class="src-var">$pValue</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a317"></a>                <span class="src-var">$titleCount</span>++<span class="src-sym">;</span></li>
<li><a name="a318"></a>            <span class="src-sym">}</span></li>
<li><a name="a319"></a>        <span class="src-sym">}</span></li>
<li><a name="a320"></a>&nbsp;</li>
<li><a name="a321"></a>        <span class="src-comm">// Eventually, add a number to the sheet name</span></li>
<li><a name="a322"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$titleCount </span>&gt; <span class="src-num">0</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a323"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetTitle">setTitle</a><span class="src-sym">(</span><span class="src-var">$pValue </span>. <span class="src-str">' ' </span>. <span class="src-var">$titleCount</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a324"></a>            <span class="src-key">return</span><span class="src-sym">;</span></li>
<li><a name="a325"></a>        <span class="src-sym">}</span></li>
<li><a name="a326"></a>                </li>
<li><a name="a327"></a>        <span class="src-comm">// Set title</span></li>
<li><a name="a328"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_title">_title</a> = <span class="src-var">$pValue</span><span class="src-sym">;</span></li>
<li><a name="a329"></a>    <span class="src-sym">}</span></li>
<li><a name="a330"></a>    </li>
<li><a name="a331"></a>    <span class="src-doc">/**</span></li>
<li><a name="a332"></a><span class="src-doc">     * Get page setup</span></li>
<li><a name="a333"></a><span class="src-doc">     *</span></li>
<li><a name="a334"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Worksheet_PageSetup </span></li>
<li><a name="a335"></a><span class="src-doc">     */</span></li>
<li><a name="a336"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetPageSetup">getPageSetup</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a337"></a>    <span class="src-sym">{</span></li>
<li><a name="a338"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_pageSetup">_pageSetup</a><span class="src-sym">;</span></li>
<li><a name="a339"></a>    <span class="src-sym">}</span></li>
<li><a name="a340"></a>    </li>
<li><a name="a341"></a>    <span class="src-doc">/**</span></li>
<li><a name="a342"></a><span class="src-doc">     * Set page setup</span></li>
<li><a name="a343"></a><span class="src-doc">     *</span></li>
<li><a name="a344"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">PHPExcel_Worksheet_PageSetup </span><span class="src-doc">   </span><span class="src-doc-var">$pValue </span></li>
<li><a name="a345"></a><span class="src-doc">     */</span></li>
<li><a name="a346"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetPageSetup">setPageSetup</a><span class="src-sym">(</span><span class="src-var">$pValue</span><span class="src-sym">)</span></li>
<li><a name="a347"></a>    <span class="src-sym">{</span></li>
<li><a name="a348"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pValue </span>instanceof <span class="src-id"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageSetup.html">PHPExcel_Worksheet_PageSetup</a></span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a349"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_pageSetup">_pageSetup</a> = <span class="src-var">$pValue</span><span class="src-sym">;</span></li>
<li><a name="a350"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a351"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid PHPExcel_Worksheet_PageSetup object passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a352"></a>        <span class="src-sym">}</span></li>
<li><a name="a353"></a>    <span class="src-sym">}</span></li>
<li><a name="a354"></a>    </li>
<li><a name="a355"></a>    <span class="src-doc">/**</span></li>
<li><a name="a356"></a><span class="src-doc">     * Get page margins</span></li>
<li><a name="a357"></a><span class="src-doc">     *</span></li>
<li><a name="a358"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Worksheet_PageMargins </span></li>
<li><a name="a359"></a><span class="src-doc">     */</span></li>
<li><a name="a360"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetPageMargins">getPageMargins</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a361"></a>    <span class="src-sym">{</span></li>
<li><a name="a362"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_pageMargins">_pageMargins</a><span class="src-sym">;</span></li>
<li><a name="a363"></a>    <span class="src-sym">}</span></li>
<li><a name="a364"></a>    </li>
<li><a name="a365"></a>    <span class="src-doc">/**</span></li>
<li><a name="a366"></a><span class="src-doc">     * Set page margins</span></li>
<li><a name="a367"></a><span class="src-doc">     *</span></li>
<li><a name="a368"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">PHPExcel_Worksheet_PageMargins </span><span class="src-doc">   </span><span class="src-doc-var">$pValue </span></li>
<li><a name="a369"></a><span class="src-doc">     */</span></li>
<li><a name="a370"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetPageMargins">setPageMargins</a><span class="src-sym">(</span><span class="src-var">$pValue</span><span class="src-sym">)</span></li>
<li><a name="a371"></a>    <span class="src-sym">{</span></li>
<li><a name="a372"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pValue </span>instanceof <span class="src-id"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageMargins.html">PHPExcel_Worksheet_PageMargins</a></span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a373"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_pageMargins">_pageMargins</a> = <span class="src-var">$pValue</span><span class="src-sym">;</span></li>
<li><a name="a374"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a375"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid PHPExcel_Worksheet_PageMargins object passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a376"></a>        <span class="src-sym">}</span></li>
<li><a name="a377"></a>    <span class="src-sym">}</span></li>
<li><a name="a378"></a>    </li>
<li><a name="a379"></a>    <span class="src-doc">/**</span></li>
<li><a name="a380"></a><span class="src-doc">     * Get page header/footer</span></li>
<li><a name="a381"></a><span class="src-doc">     *</span></li>
<li><a name="a382"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Worksheet_HeaderFooter </span></li>
<li><a name="a383"></a><span class="src-doc">     */</span></li>
<li><a name="a384"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetHeaderFooter">getHeaderFooter</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a385"></a>    <span class="src-sym">{</span></li>
<li><a name="a386"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_headerFooter">_headerFooter</a><span class="src-sym">;</span></li>
<li><a name="a387"></a>    <span class="src-sym">}</span></li>
<li><a name="a388"></a>    </li>
<li><a name="a389"></a>    <span class="src-doc">/**</span></li>
<li><a name="a390"></a><span class="src-doc">     * Set page header/footer</span></li>
<li><a name="a391"></a><span class="src-doc">     *</span></li>
<li><a name="a392"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">PHPExcel_Worksheet_HeaderFooter </span><span class="src-doc">   </span><span class="src-doc-var">$pValue </span></li>
<li><a name="a393"></a><span class="src-doc">     */</span></li>
<li><a name="a394"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetHeaderFooter">setHeaderFooter</a><span class="src-sym">(</span><span class="src-var">$pValue</span><span class="src-sym">)</span></li>
<li><a name="a395"></a>    <span class="src-sym">{</span></li>
<li><a name="a396"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pValue </span>instanceof <span class="src-id"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a></span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a397"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_headerFooter">_headerFooter</a> = <span class="src-var">$pValue</span><span class="src-sym">;</span></li>
<li><a name="a398"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a399"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid PHPExcel_Worksheet_HeaderFooter object passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a400"></a>        <span class="src-sym">}</span></li>
<li><a name="a401"></a>    <span class="src-sym">}</span></li>
<li><a name="a402"></a>    </li>
<li><a name="a403"></a>    <span class="src-doc">/**</span></li>
<li><a name="a404"></a><span class="src-doc">     * Get Protection</span></li>
<li><a name="a405"></a><span class="src-doc">     *</span></li>
<li><a name="a406"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Worksheet_Protection </span></li>
<li><a name="a407"></a><span class="src-doc">     */</span></li>
<li><a name="a408"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetProtection">getProtection</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a409"></a>    <span class="src-sym">{</span></li>
<li><a name="a410"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_protection">_protection</a><span class="src-sym">;</span></li>
<li><a name="a411"></a>    <span class="src-sym">}</span></li>
<li><a name="a412"></a>    </li>
<li><a name="a413"></a>    <span class="src-doc">/**</span></li>
<li><a name="a414"></a><span class="src-doc">     * Set Protection</span></li>
<li><a name="a415"></a><span class="src-doc">     *</span></li>
<li><a name="a416"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">PHPExcel_Worksheet_Protection </span><span class="src-doc">   </span><span class="src-doc-var">$pValue </span></li>
<li><a name="a417"></a><span class="src-doc">     */</span></li>
<li><a name="a418"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetProtection">setProtection</a><span class="src-sym">(</span><span class="src-var">$pValue</span><span class="src-sym">)</span></li>
<li><a name="a419"></a>    <span class="src-sym">{</span></li>
<li><a name="a420"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pValue </span>instanceof <span class="src-id"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Protection.html">PHPExcel_Worksheet_Protection</a></span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a421"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_protection">_protection</a> = <span class="src-var">$pValue</span><span class="src-sym">;</span></li>
<li><a name="a422"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a423"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid PHPExcel_Worksheet_Protection object passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a424"></a>        <span class="src-sym">}</span></li>
<li><a name="a425"></a>    <span class="src-sym">}</span></li>
<li><a name="a426"></a>    </li>
<li><a name="a427"></a>    <span class="src-doc">/**</span></li>
<li><a name="a428"></a><span class="src-doc">     * Get highest worksheet column</span></li>
<li><a name="a429"></a><span class="src-doc">     *</span></li>
<li><a name="a430"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc">Highest column name</span></li>
<li><a name="a431"></a><span class="src-doc">     */</span></li>
<li><a name="a432"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetHighestColumn">getHighestColumn</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a433"></a>    <span class="src-sym">{</span></li>
<li><a name="a434"></a>        <span class="src-comm">// Highest column</span></li>
<li><a name="a435"></a>        <span class="src-var">$highestColumn </span>= <span class="src-str">'A'</span><span class="src-sym">;</span></li>
<li><a name="a436"></a>        <span class="src-var">$highestColumnInteger </span>= <span class="src-num">1</span><span class="src-sym">;</span></li>
<li><a name="a437"></a>               </li>
<li><a name="a438"></a>        <span class="src-comm">// Loop trough cells</span></li>
<li><a name="a439"></a>        <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_cellCollection">_cellCollection</a> <span class="src-key">as </span><span class="src-var">$cell</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a440"></a>            <span class="src-key">if </span><span class="src-sym">(</span><span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodcolumnIndexFromString">columnIndexFromString</a><span class="src-sym">(</span><span class="src-var">$highestColumn</span><span class="src-sym">) </span>&lt; <span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodcolumnIndexFromString">columnIndexFromString</a><span class="src-sym">(</span><span class="src-var">$cell</span><span class="src-sym">-&gt;</span><span class="src-id">getColumn</span><span class="src-sym">(</span><span class="src-sym">))) </span><span class="src-sym">{</span></li>
<li><a name="a441"></a>                <span class="src-var">$highestColumn </span>= <span class="src-var">$cell</span><span class="src-sym">-&gt;</span><span class="src-id">getColumn</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a442"></a>            <span class="src-sym">}</span></li>
<li><a name="a443"></a>        <span class="src-sym">}</span></li>
<li><a name="a444"></a>&nbsp;</li>
<li><a name="a445"></a>        <span class="src-comm">// Return</span></li>
<li><a name="a446"></a>        <span class="src-key">return </span><span class="src-var">$highestColumn</span><span class="src-sym">;</span></li>
<li><a name="a447"></a>    <span class="src-sym">}</span></li>
<li><a name="a448"></a>    </li>
<li><a name="a449"></a>    <span class="src-doc">/**</span></li>
<li><a name="a450"></a><span class="src-doc">     * Get highest worksheet row</span></li>
<li><a name="a451"></a><span class="src-doc">     *</span></li>
<li><a name="a452"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">int </span><span class="src-doc">Highest row number</span></li>
<li><a name="a453"></a><span class="src-doc">     */</span></li>
<li><a name="a454"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetHighestRow">getHighestRow</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a455"></a>    <span class="src-sym">{       </span></li>
<li><a name="a456"></a>        <span class="src-comm">// Highest row</span></li>
<li><a name="a457"></a>        <span class="src-var">$highestRow </span>= <span class="src-num">1</span><span class="src-sym">;</span></li>
<li><a name="a458"></a>        </li>
<li><a name="a459"></a>        <span class="src-comm">// Loop trough cells</span></li>
<li><a name="a460"></a>        <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_cellCollection">_cellCollection</a> <span class="src-key">as </span><span class="src-var">$cell</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a461"></a>            <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$cell</span><span class="src-sym">-&gt;</span><span class="src-id">getRow</span><span class="src-sym">(</span><span class="src-sym">) </span>&gt; <span class="src-var">$highestRow</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a462"></a>                <span class="src-var">$highestRow </span>= <span class="src-var">$cell</span><span class="src-sym">-&gt;</span><span class="src-id">getRow</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a463"></a>            <span class="src-sym">}</span></li>
<li><a name="a464"></a>        <span class="src-sym">}</span></li>
<li><a name="a465"></a>        </li>
<li><a name="a466"></a>        <span class="src-comm">// Return</span></li>
<li><a name="a467"></a>        <span class="src-key">return </span><span class="src-var">$highestRow</span><span class="src-sym">;</span></li>
<li><a name="a468"></a>    <span class="src-sym">}</span></li>
<li><a name="a469"></a>    </li>
<li><a name="a470"></a>    <span class="src-doc">/**</span></li>
<li><a name="a471"></a><span class="src-doc">     * Set a cell value</span></li>
<li><a name="a472"></a><span class="src-doc">     *</span></li>
<li><a name="a473"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$pCoordinate </span><span class="src-doc">   Coordinate of the cell</span></li>
<li><a name="a474"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$pValue </span><span class="src-doc">       Value of the cell</span></li>
<li><a name="a475"></a><span class="src-doc">     */</span></li>
<li><a name="a476"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetCellValue">setCellValue</a><span class="src-sym">(</span><span class="src-var">$pCoordinate </span>= <span class="src-str">'A1'</span><span class="src-sym">, </span><span class="src-var">$pValue </span>= <span class="src-str">''</span><span class="src-sym">)</span></li>
<li><a name="a477"></a>    <span class="src-sym">{</span></li>
<li><a name="a478"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetCell">getCell</a><span class="src-sym">(</span><span class="src-var">$pCoordinate</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">setValue</span><span class="src-sym">(</span><span class="src-var">$pValue</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a479"></a>    <span class="src-sym">}</span></li>
<li><a name="a480"></a>    </li>
<li><a name="a481"></a>    <span class="src-doc">/**</span></li>
<li><a name="a482"></a><span class="src-doc">     * Set a cell value by using numeric cell coordinates</span></li>
<li><a name="a483"></a><span class="src-doc">     *</span></li>
<li><a name="a484"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$pColumn </span><span class="src-doc">       Numeric column coordinate of the cell</span></li>
<li><a name="a485"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$pRow </span><span class="src-doc">           Numeric row coordinate of the cell</span></li>
<li><a name="a486"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$pValue </span><span class="src-doc">       Value of the cell</span></li>
<li><a name="a487"></a><span class="src-doc">     */</span></li>
<li><a name="a488"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetCellValueByColumnAndRow">setCellValueByColumnAndRow</a><span class="src-sym">(</span><span class="src-var">$pColumn </span>= <span class="src-num">0</span><span class="src-sym">, </span><span class="src-var">$pRow </span>= <span class="src-num">0</span><span class="src-sym">, </span><span class="src-var">$pValue </span>= <span class="src-str">''</span><span class="src-sym">)</span></li>
<li><a name="a489"></a>    <span class="src-sym">{</span></li>
<li><a name="a490"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetCellValue">setCellValue</a><span class="src-sym">(</span><span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodstringFromColumnIndex">stringFromColumnIndex</a><span class="src-sym">(</span><span class="src-var">$pColumn</span><span class="src-sym">) </span>. <span class="src-var">$pRow</span><span class="src-sym">, </span><span class="src-var">$pValue</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a491"></a>    <span class="src-sym">}</span></li>
<li><a name="a492"></a>    </li>
<li><a name="a493"></a>    <span class="src-doc">/**</span></li>
<li><a name="a494"></a><span class="src-doc">     * Get cell at a specific coordinate</span></li>
<li><a name="a495"></a><span class="src-doc">     *</span></li>
<li><a name="a496"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">            </span><span class="src-doc-var">$pCoordinate </span><span class="src-doc">   Coordinate of the cell</span></li>
<li><a name="a497"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel_Cell </span><span class="src-doc">    Cell that was found</span></li>
<li><a name="a498"></a><span class="src-doc">     */</span></li>
<li><a name="a499"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetCell">getCell</a><span class="src-sym">(</span><span class="src-var">$pCoordinate </span>= <span class="src-str">'A1'</span><span class="src-sym">)</span></li>
<li><a name="a500"></a>    <span class="src-sym">{</span></li>
<li><a name="a501"></a>        <span class="src-comm">// Coordinates</span></li>
<li><a name="a502"></a>        <span class="src-var">$aCoordinates </span>= <span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodcoordinateFromString">coordinateFromString</a><span class="src-sym">(</span><span class="src-var">$pCoordinate</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a503"></a>        </li>
<li><a name="a504"></a>        <span class="src-comm">// Cell exists?</span></li>
<li><a name="a505"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span>isset<span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_cellCollection">_cellCollection</a><span class="src-sym">[ </span><a href="http://www.php.net/strtoupper">strtoupper</a><span class="src-sym">(</span><span class="src-var">$pCoordinate</span><span class="src-sym">) </span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a506"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_cellCollection">_cellCollection</a><span class="src-sym">[ </span><a href="http://www.php.net/strtoupper">strtoupper</a><span class="src-sym">(</span><span class="src-var">$pCoordinate</span><span class="src-sym">) </span><span class="src-sym">] </span>= <span class="src-key">new </span><span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">(</span><span class="src-var">$aCoordinates</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]</span><span class="src-sym">, </span><span class="src-var">$aCoordinates</span><span class="src-sym">[</span><span class="src-num">1</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a507"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_cellCollectionIsSorted">_cellCollectionIsSorted</a> = <span class="src-id">false</span><span class="src-sym">;</span></li>
<li><a name="a508"></a>        <span class="src-sym">}</span></li>
<li><a name="a509"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_cellCollection">_cellCollection</a><span class="src-sym">[ </span><a href="http://www.php.net/strtoupper">strtoupper</a><span class="src-sym">(</span><span class="src-var">$pCoordinate</span><span class="src-sym">) </span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a510"></a>    <span class="src-sym">}</span></li>
<li><a name="a511"></a>    </li>
<li><a name="a512"></a>    <span class="src-doc">/**</span></li>
<li><a name="a513"></a><span class="src-doc">     * Get cell at a specific coordinate by using numeric cell coordinates</span></li>
<li><a name="a514"></a><span class="src-doc">     *</span></li>
<li><a name="a515"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc-var">$pColumn </span><span class="src-doc">       Numeric column coordinate of the cell</span></li>
<li><a name="a516"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc-var">$pRow </span><span class="src-doc">       Numeric row coordinate of the cell</span></li>
<li><a name="a517"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel_Cell </span><span class="src-doc">        Cell that was found</span></li>
<li><a name="a518"></a><span class="src-doc">     */</span></li>
<li><a name="a519"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetCellByColumnAndRow">getCellByColumnAndRow</a><span class="src-sym">(</span><span class="src-var">$pColumn </span>= <span class="src-num">0</span><span class="src-sym">, </span><span class="src-var">$pRow </span>= <span class="src-num">0</span><span class="src-sym">)</span></li>
<li><a name="a520"></a>    <span class="src-sym">{</span></li>
<li><a name="a521"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetCell">getCell</a><span class="src-sym">(</span><span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodstringFromColumnIndex">stringFromColumnIndex</a><span class="src-sym">(</span><span class="src-var">$pColumn</span><span class="src-sym">) </span>. <span class="src-var">$pRow</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a522"></a>    <span class="src-sym">}</span></li>
<li><a name="a523"></a>    </li>
<li><a name="a524"></a>    <span class="src-doc">/**</span></li>
<li><a name="a525"></a><span class="src-doc">     * Get row dimension at a specific row</span></li>
<li><a name="a526"></a><span class="src-doc">     *</span></li>
<li><a name="a527"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">int </span><span class="src-doc-var">$pRow </span><span class="src-doc">   Numeric index of the row</span></li>
<li><a name="a528"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Worksheet_RowDimension </span></li>
<li><a name="a529"></a><span class="src-doc">     */</span></li>
<li><a name="a530"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetRowDimension">getRowDimension</a><span class="src-sym">(</span><span class="src-var">$pRow </span>= <span class="src-num">0</span><span class="src-sym">)</span></li>
<li><a name="a531"></a>    <span class="src-sym">{</span></li>
<li><a name="a532"></a>        <span class="src-comm">// Found</span></li>
<li><a name="a533"></a>        <span class="src-var">$found </span>= <span class="src-id">null</span><span class="src-sym">;</span></li>
<li><a name="a534"></a>        </li>
<li><a name="a535"></a>        <span class="src-comm">// Loop trough rows</span></li>
<li><a name="a536"></a>        <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_rowDimensions">_rowDimensions</a> <span class="src-key">as </span><span class="src-var">$row</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a537"></a>            <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$row</span><span class="src-sym">-&gt;</span><span class="src-id">getRowIndex</span><span class="src-sym">(</span><span class="src-sym">) </span>== <span class="src-var">$pRow</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a538"></a>                <span class="src-var">$found </span>= <span class="src-var">$row</span><span class="src-sym">;</span></li>
<li><a name="a539"></a>                <span class="src-key">break</span><span class="src-sym">;</span></li>
<li><a name="a540"></a>            <span class="src-sym">}</span></li>
<li><a name="a541"></a>        <span class="src-sym">}</span></li>
<li><a name="a542"></a>        </li>
<li><a name="a543"></a>        <span class="src-comm">// Found? If not, create a new one</span></li>
<li><a name="a544"></a>        <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$found</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a545"></a>            <span class="src-var">$found </span>= <span class="src-key">new </span><span class="src-id"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_RowDimension.html">PHPExcel_Worksheet_RowDimension</a></span><span class="src-sym">(</span><span class="src-var">$pRow</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a546"></a>            </li>
<li><a name="a547"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_rowDimensions">_rowDimensions</a><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$found</span><span class="src-sym">;</span></li>
<li><a name="a548"></a>        <span class="src-sym">}</span></li>
<li><a name="a549"></a>        </li>
<li><a name="a550"></a>        <span class="src-comm">// Return</span></li>
<li><a name="a551"></a>        <span class="src-key">return </span><span class="src-var">$found</span><span class="src-sym">;</span></li>
<li><a name="a552"></a>    <span class="src-sym">}</span></li>
<li><a name="a553"></a>       </li>
<li><a name="a554"></a>    <span class="src-doc">/**</span></li>
<li><a name="a555"></a><span class="src-doc">     * Get column dimension at a specific column</span></li>
<li><a name="a556"></a><span class="src-doc">     *</span></li>
<li><a name="a557"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$pColumn </span><span class="src-doc">   String index of the column</span></li>
<li><a name="a558"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Worksheet_ColumnDimension </span></li>
<li><a name="a559"></a><span class="src-doc">     */</span></li>
<li><a name="a560"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetColumnDimension">getColumnDimension</a><span class="src-sym">(</span><span class="src-var">$pColumn </span>= <span class="src-str">'A'</span><span class="src-sym">)</span></li>
<li><a name="a561"></a>    <span class="src-sym">{</span></li>
<li><a name="a562"></a>        <span class="src-comm">// Found</span></li>
<li><a name="a563"></a>        <span class="src-var">$found </span>= <span class="src-id">null</span><span class="src-sym">;</span></li>
<li><a name="a564"></a>        </li>
<li><a name="a565"></a>        <span class="src-comm">// Loop trough columns</span></li>
<li><a name="a566"></a>        <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_columnDimensions">_columnDimensions</a> <span class="src-key">as </span><span class="src-var">$column</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a567"></a>            <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$column</span><span class="src-sym">-&gt;</span><span class="src-id">getColumnIndex</span><span class="src-sym">(</span><span class="src-sym">) </span>== <span class="src-var">$pColumn</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a568"></a>                <span class="src-var">$found </span>= <span class="src-var">$column</span><span class="src-sym">;</span></li>
<li><a name="a569"></a>                <span class="src-key">break</span><span class="src-sym">;</span></li>
<li><a name="a570"></a>            <span class="src-sym">}</span></li>
<li><a name="a571"></a>        <span class="src-sym">}</span></li>
<li><a name="a572"></a>        </li>
<li><a name="a573"></a>        <span class="src-comm">// Found? If not, create a new one</span></li>
<li><a name="a574"></a>        <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$found</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a575"></a>            <span class="src-var">$found </span>= <span class="src-key">new </span><span class="src-id"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_ColumnDimension.html">PHPExcel_Worksheet_ColumnDimension</a></span><span class="src-sym">(</span><span class="src-var">$pColumn</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a576"></a>            </li>
<li><a name="a577"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_columnDimensions">_columnDimensions</a><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$found</span><span class="src-sym">;</span></li>
<li><a name="a578"></a>        <span class="src-sym">}</span></li>
<li><a name="a579"></a>        </li>
<li><a name="a580"></a>        <span class="src-comm">// Return</span></li>
<li><a name="a581"></a>        <span class="src-key">return </span><span class="src-var">$found</span><span class="src-sym">;</span></li>
<li><a name="a582"></a>    <span class="src-sym">}</span></li>
<li><a name="a583"></a>    </li>
<li><a name="a584"></a>    <span class="src-doc">/**</span></li>
<li><a name="a585"></a><span class="src-doc">     * Get column dimension at a specific column by using numeric cell coordinates</span></li>
<li><a name="a586"></a><span class="src-doc">     *</span></li>
<li><a name="a587"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc-var">$pColumn </span><span class="src-doc">       Numeric column coordinate of the cell</span></li>
<li><a name="a588"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc-var">$pRow </span><span class="src-doc">       Numeric row coordinate of the cell</span></li>
<li><a name="a589"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel_Worksheet_ColumnDimension </span></li>
<li><a name="a590"></a><span class="src-doc">     */</span></li>
<li><a name="a591"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetColumnDimensionByColumn">getColumnDimensionByColumn</a><span class="src-sym">(</span><span class="src-var">$pColumn </span>= <span class="src-num">0</span><span class="src-sym">)</span></li>
<li><a name="a592"></a>    <span class="src-sym">{</span></li>
<li><a name="a593"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetColumnDimension">getColumnDimension</a><span class="src-sym">(</span><span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodstringFromColumnIndex">stringFromColumnIndex</a><span class="src-sym">(</span><span class="src-var">$pColumn</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a594"></a>    <span class="src-sym">}</span></li>
<li><a name="a595"></a>    </li>
<li><a name="a596"></a>    <span class="src-doc">/**</span></li>
<li><a name="a597"></a><span class="src-doc">     * Get styles</span></li>
<li><a name="a598"></a><span class="src-doc">     *</span></li>
<li><a name="a599"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Style[] </span></li>
<li><a name="a600"></a><span class="src-doc">     */</span></li>
<li><a name="a601"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetStyles">getStyles</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a602"></a>    <span class="src-sym">{</span></li>
<li><a name="a603"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_styles">_styles</a><span class="src-sym">;</span></li>
<li><a name="a604"></a>    <span class="src-sym">}</span></li>
<li><a name="a605"></a>    </li>
<li><a name="a606"></a>    <span class="src-doc">/**</span></li>
<li><a name="a607"></a><span class="src-doc">     * Get style for cell</span></li>
<li><a name="a608"></a><span class="src-doc">     *</span></li>
<li><a name="a609"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">    </span><span class="src-doc-var">$pCellCoordinate </span><span class="src-doc">   Cell coordinate to get style for</span></li>
<li><a name="a610"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel_Style </span></li>
<li><a name="a611"></a><span class="src-doc">     */</span></li>
<li><a name="a612"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetStyle">getStyle</a><span class="src-sym">(</span><span class="src-var">$pCellCoordinate </span>= <span class="src-str">'A1'</span><span class="src-sym">)</span></li>
<li><a name="a613"></a>    <span class="src-sym">{</span></li>
<li><a name="a614"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pCellCoordinate </span>!= <span class="src-str">''</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a615"></a>            <span class="src-comm">// Create a cell for this coordinate.</span></li>
<li><a name="a616"></a>            <span class="src-comm">// Reason: When we have an empty cell that has style information,</span></li>
<li><a name="a617"></a>            <span class="src-comm">// it should exist for our IWriter</span></li>
<li><a name="a618"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetCell">getCell</a><span class="src-sym">(</span><span class="src-var">$pCellCoordinate</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a619"></a>            </li>
<li><a name="a620"></a>            <span class="src-comm">// Check if we already have style information for this cell.</span></li>
<li><a name="a621"></a>            <span class="src-comm">// If not, create a new style.</span></li>
<li><a name="a622"></a>            <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_styles">_styles</a><span class="src-sym">[</span><span class="src-var">$pCellCoordinate</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a623"></a>                <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_styles">_styles</a><span class="src-sym">[</span><span class="src-var">$pCellCoordinate</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a624"></a>            <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a625"></a>                <span class="src-var">$newStyle </span>= <span class="src-key">new </span><span class="src-id"><a href="../PHPExcel_Cell/PHPExcel_Style.html">PHPExcel_Style</a></span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a626"></a>                <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_styles">_styles</a><span class="src-sym">[</span><span class="src-var">$pCellCoordinate</span><span class="src-sym">] </span>= <span class="src-var">$newStyle</span><span class="src-sym">;</span></li>
<li><a name="a627"></a>                <span class="src-key">return </span><span class="src-var">$newStyle</span><span class="src-sym">;</span></li>
<li><a name="a628"></a>            <span class="src-sym">}</span></li>
<li><a name="a629"></a>        <span class="src-sym">}</span></li>
<li><a name="a630"></a>        </li>
<li><a name="a631"></a>        <span class="src-key">return </span><span class="src-id">null</span><span class="src-sym">;</span></li>
<li><a name="a632"></a>    <span class="src-sym">}</span></li>
<li><a name="a633"></a>    </li>
<li><a name="a634"></a>    <span class="src-doc">/**</span></li>
<li><a name="a635"></a><span class="src-doc">     * Get style for cell by using numeric cell coordinates</span></li>
<li><a name="a636"></a><span class="src-doc">     *</span></li>
<li><a name="a637"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc-var">$pColumn </span><span class="src-doc">       Numeric column coordinate of the cell</span></li>
<li><a name="a638"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc-var">$pRow </span><span class="src-doc">       Numeric row coordinate of the cell</span></li>
<li><a name="a639"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel_Style </span></li>
<li><a name="a640"></a><span class="src-doc">     */</span></li>
<li><a name="a641"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetStyleByColumnAndRow">getStyleByColumnAndRow</a><span class="src-sym">(</span><span class="src-var">$pColumn </span>= <span class="src-num">0</span><span class="src-sym">, </span><span class="src-var">$pRow </span>= <span class="src-num">0</span><span class="src-sym">)</span></li>
<li><a name="a642"></a>    <span class="src-sym">{</span></li>
<li><a name="a643"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetStyle">getStyle</a><span class="src-sym">(</span><span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodstringFromColumnIndex">stringFromColumnIndex</a><span class="src-sym">(</span><span class="src-var">$pColumn</span><span class="src-sym">) </span>. <span class="src-var">$pRow</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a644"></a>    <span class="src-sym">}</span></li>
<li><a name="a645"></a>    </li>
<li><a name="a646"></a>    <span class="src-doc">/**</span></li>
<li><a name="a647"></a><span class="src-doc">     * Duplicate cell style to a range of cells</span></li>
<li><a name="a648"></a><span class="src-doc">     *</span></li>
<li><a name="a649"></a><span class="src-doc">     * Please note that this will overwrite existing cell styles for cells in range!</span></li>
<li><a name="a650"></a><span class="src-doc">     *</span></li>
<li><a name="a651"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel_Style </span><span class="src-doc">   </span><span class="src-doc-var">$pCellStyle </span><span class="src-doc">   Cell style to duplicate</span></li>
<li><a name="a652"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">           </span><span class="src-doc-var">$pRange </span><span class="src-doc">       Range of cells (i.e. &quot;A1:B10&quot;), or just one cell (i.e. &quot;A1&quot;)</span></li>
<li><a name="a653"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">    Exception</span></li>
<li><a name="a654"></a><span class="src-doc">     */</span></li>
<li><a name="a655"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodduplicateStyle">duplicateStyle</a><span class="src-sym">(</span><span class="src-var">$pCellStyle </span>= <span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$pRange </span>= <span class="src-str">''</span><span class="src-sym">)</span></li>
<li><a name="a656"></a>    <span class="src-sym">{</span></li>
<li><a name="a657"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pCellStyle </span>instanceof <span class="src-id"><a href="../PHPExcel_Cell/PHPExcel_Style.html">PHPExcel_Style</a></span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a658"></a>            <span class="src-comm">// Is it a cell range or a single cell?</span></li>
<li><a name="a659"></a>            <span class="src-var">$rangeA     </span>= <span class="src-str">''</span><span class="src-sym">;</span></li>
<li><a name="a660"></a>            <span class="src-var">$rangeB     </span>= <span class="src-str">''</span><span class="src-sym">;</span></li>
<li><a name="a661"></a>            <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/strpos">strpos</a><span class="src-sym">(</span><span class="src-var">$pRange</span><span class="src-sym">, </span><span class="src-str">':'</span><span class="src-sym">) </span>=== <span class="src-id">false</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a662"></a>                <span class="src-var">$rangeA </span>= <span class="src-var">$pRange</span><span class="src-sym">;</span></li>
<li><a name="a663"></a>                <span class="src-var">$rangeB </span>= <span class="src-var">$pRange</span><span class="src-sym">;</span></li>
<li><a name="a664"></a>            <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a665"></a>                list<span class="src-sym">(</span><span class="src-var">$rangeA</span><span class="src-sym">, </span><span class="src-var">$rangeB</span><span class="src-sym">) </span>= <a href="http://www.php.net/explode">explode</a><span class="src-sym">(</span><span class="src-str">':'</span><span class="src-sym">, </span><span class="src-var">$pRange</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a666"></a>            <span class="src-sym">}</span></li>
<li><a name="a667"></a>            </li>
<li><a name="a668"></a>            <span class="src-comm">// Calculate range outer borders</span></li>
<li><a name="a669"></a>            <span class="src-var">$rangeStart </span>= <span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodcoordinateFromString">coordinateFromString</a><span class="src-sym">(</span><span class="src-var">$rangeA</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a670"></a>            <span class="src-var">$rangeEnd     </span>= <span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodcoordinateFromString">coordinateFromString</a><span class="src-sym">(</span><span class="src-var">$rangeB</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a671"></a>            </li>
<li><a name="a672"></a>            <span class="src-comm">// Translate column into index</span></li>
<li><a name="a673"></a>            <span class="src-var">$rangeStart</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]    </span>= <span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodcolumnIndexFromString">columnIndexFromString</a><span class="src-sym">(</span><span class="src-var">$rangeStart</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]</span><span class="src-sym">) </span>- <span class="src-num">1</span><span class="src-sym">;</span></li>
<li><a name="a674"></a>            <span class="src-var">$rangeEnd</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]    </span>= <span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodcolumnIndexFromString">columnIndexFromString</a><span class="src-sym">(</span><span class="src-var">$rangeEnd</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]</span><span class="src-sym">) </span>- <span class="src-num">1</span><span class="src-sym">;</span></li>
<li><a name="a675"></a>            </li>
<li><a name="a676"></a>            <span class="src-comm">// Make sure we can loop upwards on rows and columns</span></li>
<li><a name="a677"></a>            <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$rangeStart</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">] </span>&gt; <span class="src-var">$rangeEnd</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">] </span>&amp;&amp; <span class="src-var">$rangeStart</span><span class="src-sym">[</span><span class="src-num">1</span><span class="src-sym">] </span>&gt; <span class="src-var">$rangeEnd</span><span class="src-sym">[</span><span class="src-num">1</span><span class="src-sym">]</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a678"></a>                <span class="src-var">$tmp </span>= <span class="src-var">$rangeStart</span><span class="src-sym">;</span></li>
<li><a name="a679"></a>                <span class="src-var">$rangeStart </span>= <span class="src-var">$rangeEnd</span><span class="src-sym">;</span></li>
<li><a name="a680"></a>                <span class="src-var">$rangeEnd </span>= <span class="src-var">$tmp</span><span class="src-sym">;</span></li>
<li><a name="a681"></a>            <span class="src-sym">}</span></li>
<li><a name="a682"></a>                       </li>
<li><a name="a683"></a>            <span class="src-comm">// Loop trough cells and apply styles</span></li>
<li><a name="a684"></a>            <span class="src-key">for </span><span class="src-sym">(</span><span class="src-var">$col </span>= <span class="src-var">$rangeStart</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]</span><span class="src-sym">; </span><span class="src-var">$col </span>&lt;= <span class="src-var">$rangeEnd</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]</span><span class="src-sym">; </span><span class="src-var">$col</span>++<span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a685"></a>                <span class="src-key">for </span><span class="src-sym">(</span><span class="src-var">$row </span>= <span class="src-var">$rangeStart</span><span class="src-sym">[</span><span class="src-num">1</span><span class="src-sym">]</span><span class="src-sym">; </span><span class="src-var">$row </span>&lt;= <span class="src-var">$rangeEnd</span><span class="src-sym">[</span><span class="src-num">1</span><span class="src-sym">]</span><span class="src-sym">; </span><span class="src-var">$row</span>++<span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a686"></a>                    <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_styles">_styles</a><span class="src-sym">[ </span><span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodstringFromColumnIndex">stringFromColumnIndex</a><span class="src-sym">(</span><span class="src-var">$col</span><span class="src-sym">) </span>. <span class="src-var">$row </span><span class="src-sym">] </span>= <span class="src-var">$pCellStyle</span><span class="src-sym">-&gt;</span><span class="src-id">duplicate</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a687"></a>                <span class="src-sym">}</span></li>
<li><a name="a688"></a>            <span class="src-sym">}</span></li>
<li><a name="a689"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a690"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid PHPExcel_Style object passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a691"></a>        <span class="src-sym">}</span></li>
<li><a name="a692"></a>    <span class="src-sym">}</span></li>
<li><a name="a693"></a>    </li>
<li><a name="a694"></a>    <span class="src-doc">/**</span></li>
<li><a name="a695"></a><span class="src-doc">     * Set break on a cell</span></li>
<li><a name="a696"></a><span class="src-doc">     *</span></li>
<li><a name="a697"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">           </span><span class="src-doc-var">$pCell </span><span class="src-doc">       Cell coordinate (e.g. A1)</span></li>
<li><a name="a698"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">int </span><span class="src-doc">               </span><span class="src-doc-var">$pBreak </span><span class="src-doc">       Break type (type of PHPExcel_Worksheet::BREAK_*)</span></li>
<li><a name="a699"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">    Exception</span></li>
<li><a name="a700"></a><span class="src-doc">     */</span></li>
<li><a name="a701"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetBreak">setBreak</a><span class="src-sym">(</span><span class="src-var">$pCell </span>= <span class="src-str">'A1'</span><span class="src-sym">, </span><span class="src-var">$pBreak </span>= <span class="src-id">PHPExcel_Worksheet</span><span class="src-sym">::</span><span class="src-id">BREAK_NONE</span><span class="src-sym">)</span></li>
<li><a name="a702"></a>    <span class="src-sym">{</span></li>
<li><a name="a703"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pCell </span>!= <span class="src-str">''</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a704"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_breaks">_breaks</a><span class="src-sym">[</span><a href="http://www.php.net/strtoupper">strtoupper</a><span class="src-sym">(</span><span class="src-var">$pCell</span><span class="src-sym">)</span><span class="src-sym">] </span>= <span class="src-var">$pBreak</span><span class="src-sym">;</span></li>
<li><a name="a705"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a706"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">'No cell coordinate specified.'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a707"></a>        <span class="src-sym">}</span></li>
<li><a name="a708"></a>    <span class="src-sym">}</span></li>
<li><a name="a709"></a>    </li>
<li><a name="a710"></a>    <span class="src-doc">/**</span></li>
<li><a name="a711"></a><span class="src-doc">     * Set break on a cell by using numeric cell coordinates</span></li>
<li><a name="a712"></a><span class="src-doc">     *</span></li>
<li><a name="a713"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">    </span><span class="src-doc-var">$pColumn </span><span class="src-doc">   Numeric column coordinate of the cell</span></li>
<li><a name="a714"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">    </span><span class="src-doc-var">$pRow </span><span class="src-doc">       Numeric row coordinate of the cell</span></li>
<li><a name="a715"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">int </span><span class="src-doc">       </span><span class="src-doc-var">$pBreak </span><span class="src-doc">       Break type (type of PHPExcel_Worksheet::BREAK_*)</span></li>
<li><a name="a716"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">    Exception</span></li>
<li><a name="a717"></a><span class="src-doc">     */</span></li>
<li><a name="a718"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetBreakByColumnAndRow">setBreakByColumnAndRow</a><span class="src-sym">(</span><span class="src-var">$pColumn </span>= <span class="src-num">0</span><span class="src-sym">, </span><span class="src-var">$pRow </span>= <span class="src-num">0</span><span class="src-sym">, </span><span class="src-var">$pBreak </span>= <span class="src-id">PHPExcel_Worksheet</span><span class="src-sym">::</span><span class="src-id">BREAK_NONE</span><span class="src-sym">)</span></li>
<li><a name="a719"></a>    <span class="src-sym">{</span></li>
<li><a name="a720"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetBreak">setBreak</a><span class="src-sym">(</span><span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodstringFromColumnIndex">stringFromColumnIndex</a><span class="src-sym">(</span><span class="src-var">$pColumn</span><span class="src-sym">) </span>. <span class="src-var">$pRow</span><span class="src-sym">, </span><span class="src-var">$pBreak</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a721"></a>    <span class="src-sym">}</span></li>
<li><a name="a722"></a>    </li>
<li><a name="a723"></a>    <span class="src-doc">/**</span></li>
<li><a name="a724"></a><span class="src-doc">     * Get breaks</span></li>
<li><a name="a725"></a><span class="src-doc">     *</span></li>
<li><a name="a726"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array[] </span></li>
<li><a name="a727"></a><span class="src-doc">     */</span></li>
<li><a name="a728"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetBreaks">getBreaks</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a729"></a>    <span class="src-sym">{</span></li>
<li><a name="a730"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_breaks">_breaks</a><span class="src-sym">;</span></li>
<li><a name="a731"></a>    <span class="src-sym">}</span></li>
<li><a name="a732"></a>    </li>
<li><a name="a733"></a>    <span class="src-doc">/**</span></li>
<li><a name="a734"></a><span class="src-doc">     * Set merge on a cell range</span></li>
<li><a name="a735"></a><span class="src-doc">     *</span></li>
<li><a name="a736"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">           </span><span class="src-doc-var">$pRange </span><span class="src-doc">       Cell range (e.g. A1:E1)</span></li>
<li><a name="a737"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">    Exception</span></li>
<li><a name="a738"></a><span class="src-doc">     */</span></li>
<li><a name="a739"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodmergeCells">mergeCells</a><span class="src-sym">(</span><span class="src-var">$pRange </span>= <span class="src-str">'A1:A1'</span><span class="src-sym">)</span></li>
<li><a name="a740"></a>    <span class="src-sym">{</span></li>
<li><a name="a741"></a>        <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/eregi">eregi</a><span class="src-sym">(</span><span class="src-str">':'</span><span class="src-sym">, </span><span class="src-var">$pRange</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a742"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_mergeCells">_mergeCells</a><span class="src-sym">[</span><span class="src-var">$pRange</span><span class="src-sym">] </span>= <span class="src-var">$pRange</span><span class="src-sym">;</span></li>
<li><a name="a743"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a744"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">'Merge must be set on a range of cells.'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a745"></a>        <span class="src-sym">}</span></li>
<li><a name="a746"></a>    <span class="src-sym">}</span></li>
<li><a name="a747"></a>    </li>
<li><a name="a748"></a>    <span class="src-doc">/**</span></li>
<li><a name="a749"></a><span class="src-doc">     * Remove merge on a cell range</span></li>
<li><a name="a750"></a><span class="src-doc">     *</span></li>
<li><a name="a751"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">           </span><span class="src-doc-var">$pRange </span><span class="src-doc">       Cell range (e.g. A1:E1)</span></li>
<li><a name="a752"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">    Exception</span></li>
<li><a name="a753"></a><span class="src-doc">     */</span></li>
<li><a name="a754"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodunmergeCells">unmergeCells</a><span class="src-sym">(</span><span class="src-var">$pRange </span>= <span class="src-str">'A1:A1'</span><span class="src-sym">)</span></li>
<li><a name="a755"></a>    <span class="src-sym">{</span></li>
<li><a name="a756"></a>        <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/eregi">eregi</a><span class="src-sym">(</span><span class="src-str">':'</span><span class="src-sym">, </span><span class="src-var">$pRange</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a757"></a>            <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_mergeCells">_mergeCells</a><span class="src-sym">[</span><span class="src-var">$pRange</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a758"></a>                unset<span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_mergeCells">_mergeCells</a><span class="src-sym">[</span><span class="src-var">$pRange</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a759"></a>            <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a760"></a>                throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">'Cell range ' </span>. <span class="src-var">$pRange </span>. <span class="src-str">' not known as merged.'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a761"></a>            <span class="src-sym">}</span></li>
<li><a name="a762"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a763"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">'Merge can only be removed from a range of cells.'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a764"></a>        <span class="src-sym">}</span></li>
<li><a name="a765"></a>    <span class="src-sym">}</span></li>
<li><a name="a766"></a>    </li>
<li><a name="a767"></a>    <span class="src-doc">/**</span></li>
<li><a name="a768"></a><span class="src-doc">     * Get merge cells</span></li>
<li><a name="a769"></a><span class="src-doc">     *</span></li>
<li><a name="a770"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array[] </span></li>
<li><a name="a771"></a><span class="src-doc">     */</span></li>
<li><a name="a772"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetMergeCells">getMergeCells</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a773"></a>    <span class="src-sym">{</span></li>
<li><a name="a774"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_mergeCells">_mergeCells</a><span class="src-sym">;</span></li>
<li><a name="a775"></a>    <span class="src-sym">}</span></li>
<li><a name="a776"></a>    </li>
<li><a name="a777"></a>    <span class="src-doc">/**</span></li>
<li><a name="a778"></a><span class="src-doc">     * Set protection on a cell range</span></li>
<li><a name="a779"></a><span class="src-doc">     *</span></li>
<li><a name="a780"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">           </span><span class="src-doc-var">$pRange </span><span class="src-doc">               Cell (e.g. A1) or cell range (e.g. A1:E1)</span></li>
<li><a name="a781"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">           </span><span class="src-doc-var">$pPassword </span><span class="src-doc">           Password to unlock the protection</span></li>
<li><a name="a782"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">boolean </span><span class="src-doc">        </span><span class="src-doc-var">$pAlreadyHashed </span><span class="src-doc">    If the password has already been hashed, set this to true</span></li>
<li><a name="a783"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">    Exception</span></li>
<li><a name="a784"></a><span class="src-doc">     */</span></li>
<li><a name="a785"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodprotectCells">protectCells</a><span class="src-sym">(</span><span class="src-var">$pRange </span>= <span class="src-str">'A1'</span><span class="src-sym">, </span><span class="src-var">$pPassword </span>= <span class="src-str">''</span><span class="src-sym">, </span><span class="src-var">$pAlreadyHashed </span>= <span class="src-id">false</span><span class="src-sym">)</span></li>
<li><a name="a786"></a>    <span class="src-sym">{</span></li>
<li><a name="a787"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><span class="src-var">$pAlreadyHashed</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a788"></a>            <span class="src-var">$pPassword </span>= <span class="src-id"><a href="../PHPExcel_Shared/PHPExcel_Shared_PasswordHasher.html">PHPExcel_Shared_PasswordHasher</a></span><span class="src-sym">::</span><a href="../PHPExcel_Shared/PHPExcel_Shared_PasswordHasher.html#methodhashPassword">hashPassword</a><span class="src-sym">(</span><span class="src-var">$pPassword</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a789"></a>        <span class="src-sym">}</span></li>
<li><a name="a790"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_protectedCells">_protectedCells</a><span class="src-sym">[</span><span class="src-var">$pRange</span><span class="src-sym">] </span>= <span class="src-var">$pPassword</span><span class="src-sym">;</span></li>
<li><a name="a791"></a>    <span class="src-sym">}</span></li>
<li><a name="a792"></a>    </li>
<li><a name="a793"></a>    <span class="src-doc">/**</span></li>
<li><a name="a794"></a><span class="src-doc">     * Remove protection on a cell range</span></li>
<li><a name="a795"></a><span class="src-doc">     *</span></li>
<li><a name="a796"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">           </span><span class="src-doc-var">$pRange </span><span class="src-doc">       Cell (e.g. A1) or cell range (e.g. A1:E1)</span></li>
<li><a name="a797"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">    Exception</span></li>
<li><a name="a798"></a><span class="src-doc">     */</span></li>
<li><a name="a799"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodunprotectCells">unprotectCells</a><span class="src-sym">(</span><span class="src-var">$pRange </span>= <span class="src-str">'A11'</span><span class="src-sym">)</span></li>
<li><a name="a800"></a>    <span class="src-sym">{</span></li>
<li><a name="a801"></a>        <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_protectedCells">_protectedCells</a><span class="src-sym">[</span><span class="src-var">$pRange</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a802"></a>            unset<span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_protectedCells">_protectedCells</a><span class="src-sym">[</span><span class="src-var">$pRange</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a803"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a804"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">'Cell range ' </span>. <span class="src-var">$pRange </span>. <span class="src-str">' not known as protected.'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a805"></a>        <span class="src-sym">}</span></li>
<li><a name="a806"></a>    <span class="src-sym">}</span></li>
<li><a name="a807"></a>    </li>
<li><a name="a808"></a>    <span class="src-doc">/**</span></li>
<li><a name="a809"></a><span class="src-doc">     * Get protected cells</span></li>
<li><a name="a810"></a><span class="src-doc">     *</span></li>
<li><a name="a811"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array[] </span></li>
<li><a name="a812"></a><span class="src-doc">     */</span></li>
<li><a name="a813"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetProtectedCells">getProtectedCells</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a814"></a>    <span class="src-sym">{</span></li>
<li><a name="a815"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_protectedCells">_protectedCells</a><span class="src-sym">;</span></li>
<li><a name="a816"></a>    <span class="src-sym">}</span></li>
<li><a name="a817"></a>    </li>
<li><a name="a818"></a>    <span class="src-doc">/**</span></li>
<li><a name="a819"></a><span class="src-doc">     * Get Autofilter Range</span></li>
<li><a name="a820"></a><span class="src-doc">     *</span></li>
<li><a name="a821"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span></li>
<li><a name="a822"></a><span class="src-doc">     */</span></li>
<li><a name="a823"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetAutoFilter">getAutoFilter</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a824"></a>    <span class="src-sym">{</span></li>
<li><a name="a825"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_autoFilter">_autoFilter</a><span class="src-sym">;</span></li>
<li><a name="a826"></a>    <span class="src-sym">}</span></li>
<li><a name="a827"></a>    </li>
<li><a name="a828"></a>    <span class="src-doc">/**</span></li>
<li><a name="a829"></a><span class="src-doc">     * Set Autofilter Range</span></li>
<li><a name="a830"></a><span class="src-doc">     *</span></li>
<li><a name="a831"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">       </span><span class="src-doc-var">$pRange </span><span class="src-doc">       Cell range (i.e. A1:E10)</span></li>
<li><a name="a832"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a833"></a><span class="src-doc">     */</span></li>
<li><a name="a834"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodsetAutoFilter">setAutoFilter</a><span class="src-sym">(</span><span class="src-var">$pRange </span>= <span class="src-str">''</span><span class="src-sym">)</span></li>
<li><a name="a835"></a>    <span class="src-sym">{</span></li>
<li><a name="a836"></a>        <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/eregi">eregi</a><span class="src-sym">(</span><span class="src-str">':'</span><span class="src-sym">, </span><span class="src-var">$pRange</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a837"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_autoFilter">_autoFilter</a> = <span class="src-var">$pRange</span><span class="src-sym">;</span></li>
<li><a name="a838"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a839"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">'Autofilter must be set on a range of cells.'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a840"></a>        <span class="src-sym">}</span></li>
<li><a name="a841"></a>    <span class="src-sym">}</span></li>
<li><a name="a842"></a>    </li>
<li><a name="a843"></a>    <span class="src-doc">/**</span></li>
<li><a name="a844"></a><span class="src-doc">     * Get hash code</span></li>
<li><a name="a845"></a><span class="src-doc">     *</span></li>
<li><a name="a846"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc">   Hash code</span></li>
<li><a name="a847"></a><span class="src-doc">     */    </span></li>
<li><a name="a848"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodgetHashCode">getHashCode</a><span class="src-sym">(</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a849"></a>        <span class="src-key">return </span><a href="http://www.php.net/md5">md5</a><span class="src-sym">(</span></li>
<li><a name="a850"></a>              <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_title">_title</a></li>
<li><a name="a851"></a>            . <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_autoFilter">_autoFilter</a></li>
<li><a name="a852"></a>            . <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#var$_protection">_protection</a><span class="src-sym">-&gt;</span><span class="src-id">isProtectionEnabled</span><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a853"></a>            . <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodcalculateWorksheetDimension">calculateWorksheetDimension</a><span class="src-sym">(</span><span class="src-sym">)</span></li>
<li><a name="a854"></a>            . __CLASS__</li>
<li><a name="a855"></a>        <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a856"></a>    <span class="src-sym">}</span></li>
<li><a name="a857"></a>        </li>
<li><a name="a858"></a>    <span class="src-doc">/**</span></li>
<li><a name="a859"></a><span class="src-doc">     * Duplicate object</span></li>
<li><a name="a860"></a><span class="src-doc">     *</span></li>
<li><a name="a861"></a><span class="src-doc">     * Duplicates the current object, also duplicating referenced objects (deep cloning).</span></li>
<li><a name="a862"></a><span class="src-doc">     * Standard PHP clone does not copy referenced objects!</span></li>
<li><a name="a863"></a><span class="src-doc">     *</span></li>
<li><a name="a864"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">PHPExcel_Worksheet </span></li>
<li><a name="a865"></a><span class="src-doc">     */</span></li>
<li><a name="a866"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel/PHPExcel_Worksheet.html#methodduplicate">duplicate</a><span class="src-sym">(</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a867"></a>        <span class="src-key">return </span><a href="http://www.php.net/unserialize">unserialize</a><span class="src-sym">(</span><a href="http://www.php.net/serialize">serialize</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a868"></a>    <span class="src-sym">}</span></li>
<li><a name="a869"></a><span class="src-sym">}</span></li>
</ol></pre></div>
</div>
        <div class="credit">
		    <hr />
		    Documentation generated on Mon, 23 Apr 2007 12:57:07 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.3.0RC3</a>
	      </div>
      </td></tr></table>
    </td>
  </tr>
</table>

</body>
</html>